| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
| ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | ItemDimension(ETL_DW3_DIM_ITM) |
| BusinessUnitID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN | Identity | integer | LocationDimension(ETL_DW3_DIM_INVENTORY_LOCATION) |
| LocationID (FK)(PK) | A unique system assigned identifier for the Location. | ID_LCN | Identity | int | LocationDimension(ETL_DW3_DIM_INVENTORY_LOCATION) |
| ItemInventoryStateID (FK)(PK) | A unique retailer assigned identifier for ItemInventoryStates. | ID_ST_INV | Identity | integer | InventoryState(CO_ST_INV) |
| RevenueCostCenterID (FK)(PK) | A unique retailer assigned identifier for an accounting budget, that owns merchandise and is used to track the financial performance of the retail enterprise. | ID_CTR_RVN_CST | Identity | integer | RevenueCostCenter(CO_CTR_RVN_CST) |
| ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
| CalendarReportingPeriodID | Token identifier for a Reporting Period. Uniquely identifies a reporting period. | ID_PRD_RP_CLD | Number | int | |
| FirstReceiptDate | The date this item is first received into the retailer's inventory system. Inventory system in this context includes warehouses, distribution centers or stores -- any place the retailer may receive merchandise. This attribute will be populated using a query looking for the oldest reporting period for the item in the ItemInventoryHistory set. (See ReportingID definition for a discussion of the relationsip between reporting period and business day). | DC_INV_FS_RCPT | DateCalendar | date | |
| LastReceiptDate | The date this item was last received into the retailer's inventory system. Inventory system in this context includes warehouses, distribution centers or stores -- any place the retailer may receive merchandise. This attribute will be populated using a query looking for the newest reporting period for the item in the ItemInventoryHistory set. (See ReportingID definition for a discussion of the relationsip between reporting period and business day). | DC_INV_LS_RCPT | DateCalendar | date | |
| CurrentSaleUnitRetailPriceAmount | The current retail price per sale unit of the item. This monetary amount is used as the basis for deriving retail price at the point of sale. | MO_UN_RTL | MoneyShortRetail | decimal(7,2) | |
| UnitCost | The weighted average cost for each retail sale unit of this item at the current time. | MO_UN_CST | MoneyShortCost | decimal(16,5) | |
| OnOrderCount | The count of retail units that are on order during the period (i.e.purchases that have not been received into inventory). This attribute value is aggregated from the OrderDocument type of InventoryControlDocument ICDMerchandiseLineItem Unit Count. Because this reflects the period count of both units ordered this period plus units ordered in previous periods that have not been received and are NOT IN TRANSIT (because intransit items are legally owned by the retailer). This requires a query to look across orders, intransits and receiving documents to determine the on order count. This is an important number for merchandise open to buy planning and control. | QU_ON_ORD_CNT | Quantity | decimal(38,2) | |
| OnOrderCost | The extended UnitNetCostAmount of this item multiplied by the UnitCount on order. This attribute is derived by looking at OrderDocument type of InventoryControlDocument and the ICDMerchandiseLineItem entity type's UnitCount and UnitNetCost attributes. Like OnOrderCount care must be taek to ensure that this value reflects the value of current period orders plus prior period orders that have not yet been received and are not in transit. | MO_ON_ORD_CST | Money | decimal(38,7) | |
| OnOrderRetailAmount | This value is the retail valuation (in monetary units)placed on items that are currently on order. The cost attributes, as discussed in OnOrderCost are available by interrogating the inventory control document line items for order ICD's associated with the item. The retail valuation for on order items will be extracted from the ItemSellingPrices CurrentSaleUnitRetailPriceAmount attribute. This assumes that the Inventory Fact entity is updated on a daily basis Isince it only includes the current and possibly future retail prices). If this assumption is not true, a second source , the PermanentPriceChangeItem entity NewPrice entity type will be used. The PermanentPriceChangeEffectiveDateTime will be compared with ReportingPeriod business day to obtain the correct version of the retail price. | MO_ON_ORD_RTL_AMT | Money | decimal(38,4) | |
| IntransitCount | The count of retail units that are legally and financially owned by the retailer but are physically in the posssession of a carrier. They are "in bound" but not yet received. For the purposes of this model intransit items are reflected in the InventoryControlDocument type advanced ship notice CDMerchandiseLineItem UnitCount attribute. As with other fact attributes, this one is an aggregation of these individual document unit counts for the relevant reporting period. All "open" ASN's are aggregate to arrive at this value. This requires that upon receipt of the merchanse, the ASN is marked as received and not included in the next periods aggregation select. We are NOT including intra-retailer inventory transfers as part of intransit unit counts, costs and retail. These are accounted for in the tranfer in/ transfer out movement where inventory ownership is passed from one CostRevenueCenter to another. The basis for this is that the retail enterprise financially and physically owns the items if they're being transferred within the enterprise. | QU_INTRST_CNT | Quantity | decimal(38,2) | |
| IntransitCost | The extended UnitNetCostAmount of this item multiplied by the UnitCount on the AdvancedShipNotice subtype of InventoryControlDocument ICDMerchandiseLineItem UnitNetCost. The data model assumes that all inventory control document types have one or more ICDMerchandise LineItem's. This version of the DW model extends this assumption to include ICDMerchandiseLineItems which provide unit counts and unt net cost. | MO_INTRST_CST | Money | decimal(38,7) | |
| IntransitRetailAmount | This value is the retail valuation placed on items that are currently in transit (inbound based on advanced ship notice ICD types). The cost attributes, as discussed in OnOrderCost are available by interrogating the inventory control document line items for order ICD's associated with the item. The retail valuation for on order items will be extracted from the ItemSellingPrices CurrentSaleUnitRetailPriceAmount attribute. This assumes that the Inventory Fact entity is updated on a daily basis Isince it only includes the current and possibly future retail prices). If this assumption is not true, a second source , the PermanentPriceChangeItem entity NewPrice entity type will be used. The PermanentPriceChangeEffectiveDateTime will be compared with ReportingPeriod business day to obtain the correct version of the retail price. | MO_INTRST_RTL | Money | decimal(38,4) | |
| MarkdownCycleCode | Markdown cycle code is a retailer defined value that identifies which markdown this item is in. This definition assumes that a retailer has a defined retail price lifecycle that incorporates a sequence of markdown stages. For example a fashion retailer may establish 4 markdown cycles for a class of womens' apparel which might include - initial markdown, second markdown, third markdown, clearance rack and markdown. This provides a quick snapshot of an item's retail price life cycle stage. This attribute will be derived from the PermanentRetailPricePermanentMarkdownCount attribute of the ItemSellingPrices entity type. We use the term derived because the cycle type could be the same as the count or it may be a reference value associated with a markdown count. This derivation is implemented in the ETL rules used to populate the INVENTORY FACT entity type from the ODS. | CD_MKD_CYCL | String | char(4) | |
| ItemDiscountUnitCount | The number of ITEMs that had an ordinary discount applied to during the REPORTING PERIOD | QU_DSC_ITM | Quantity | decimal(9,2) | |
| BeginningUnitCount | The number of units of the nominated Item present in the nominated InventoryLocation at the beginning of the nominated ReportingPeriod. | QU_BGN | Quantity | decimal(9,2) | |
| ReceivedUnitCount | The number of units of the nominated Item received to the nominated InventoryLocation since the beginning of the nominated ReportingPeriod, excluding any returns. | QU_RCV | Quantity | decimal(9,2) | |
| TransferInUnitCount | The number of units of the nominated Item transferred into the nominated InventoryLocation since the beginning of the nominated ReportingPeriod. Note: Transfers include any Item's for which InventoryState was changed, but InventoryLocation did not change. | QU_TSF_IN | Quantity | decimal(9,2) | |
| TransferOutUnitCount | The number of units of the nominated Item transferred from the nominated InventoryLocation since the beginning of the nominated ReportingPeriod. Note: Transfers include any Item's for which InventoryState was changed, but InventoryLocation did not change. | QU_TSF_OT | Quantity | decimal(9,2) | |
| AdjustmentUnitCount | The number of units of the nominated Item for which InventoryAdjustments were made in the nominated InventoryLocation since the beginning of the nominated ReportingPeriod. | QU_ADJT | Quantity | decimal(9,2) | |
| ReturnUnitCount | The number of units of the nominated Item returned to the nominated InventoryLocation since the beginning of the nominated ReportingPeriod. | QU_RTN | Quantity | decimal(9,2) | |
| GrossSalesUnitCount | The number of units of the nominated Item sold from the nominated InventoryLocation since the beginning of the nominated ReportingPeriod, excluding any returns. | QU_SLS | Quantity | decimal(9,2) | |
| ReturnToVendorUnitCount | The number of units of the nominated Item returned to Vendor from the nominated InventoryLocation since the beginning of the nominated ReportingPeriod. | QU_RTV | Quantity | decimal(9,2) | |
| EndingUnitCount | The number of units of the nominated Item present in the nominated InventoryLocation at the end of the nominated ReportingPeriod. | QU_END | Quantity | decimal(9,2) | |
| BeginningAverageWeightedUnitCost | The weighted average cost for each retail sale unit of this item at the beginning of the current ReportingPeriod. The weighted average cost is updated each time a shipment of this item is received by the owning MerchandisingRevenueCenter. | CP_UN_AV_WT_BGN | MoneyShortCost | decimal(16,5) | |
| EndingAverageWeightedUnitCost | The current weighted average cost for each retail sale unit of this item at the end of the historical ReportingPeriod. Extracted from the CostValueLedgerAccountHistory entity for the relevant period | CP_UN_AV_WT_END | MoneyShortCost | decimal(16,5) | |
| CumulativeReceivedCostAmount | The cumulative cost value of units received by the MerchandisingRevenueCenter since the beginning of the current ReportingPeriod. This figure is used to update the AverageWeightedUnitCost of Items during the ReportingPeriod. | TC_RCV_CM | Money | decimal(16,5) | |
| CumulativeReceivedRetailAmount | The cumulative retail value of units received for a particular ITEM since the beginning of the current ReportingPeriod. | TP_RCV | Money | decimal(16,5) | |
| BeginningValueAmount | The monetary value of all Items owned by the MerchandisingCenter at the beginning of the current ReportingPeriod | MO_VL_BGN | Money | decimal(16,5) | |
| BeginningCumulativeMarkonAmount | The markon amount (initial markon) at the beginning of the current ReportingPeriod. | MO_MKN_CM | Money | decimal(16,5) | |
| BeginningCumulativeMarkonPercent | The markon percentage (initial markon) at the beginning of the current ReportingPeriod. | PE_MKN_CM | Percent | decimal(7,4) | |
| CumulativeGrossSalesRetailAmount | The cumulative gross sales for a specific ITEM since the beginning of the current ReportingPeriod. The gross figure excludes returns. | TP_SLS_GS_CM | Money | decimal(16,5) | |
| CumulativeReturnRetailAmount | The cumulative retail value of merchandise that is returned by customers to the RetailStore during the current ReportingPeriod. | TP_RTN | Money | decimal(16,5) | |
| CumulativeTransferInRetailAmount | The cumulative retail value of merchandise transferred into the store from other stores or distribution centers during the current ReportingPeriod. | MO_TSF_IN_CM | Money | decimal(16,5) | |
| CumulativeTransferOutRetailAmount | The cumulative retail value of merchandise transferred from the store to another store or distribution center during the current ReportingPeriod. | MO_TSF_OT_CM | Money | decimal(16,5) | |
| CumulativeReturnToVendorRetailAmount | The cumulative retail value of merchandise returned to the vendor from the store during the current ReportingPeriod. | TP_RTN_TO_VN | Money | decimal(16,5) | |
| CumulativeAdjustmentRetailAmount | The cumulative retail value of inventory adjustments (overages and shortages) made to ItemInventory during the current ReportingPeriod. | MO_ADJT_RT_CM | Money | decimal(16,5) | |
| CumulativePermanentMarkdownAmount | The cumulative value of permanent markdowns taken against this item during the current ReportingPeriod. | MO_MKD_PRN_CM | Money | decimal(16,5) | |
| CumulativeTemporaryMarkdownAmount | The cumulative temporary or promotional markdown value taken against this item either as a price change or through the application of price derivation rules at the point of sale during the current ReportingPeriod. | MO_MKD_TMP_CM | Money | decimal(16,5) | |
| CumulativePermanentMarkupAmount | The cumulative value of permanent markups taken against this item during the current ReportingPeriod. | MO_MKP_PRN_CM | Money | decimal(16,5) | |
| CumulativeTemporaryMarkupAmount | The cumulative temporary or promotional markup value taken against this item either as a price change or through the application of price derivation rules at the point of sale, during the current ReportingPeriod. | MO_MKP_TMP_CM | Money | decimal(16,5) | |
| CumulativeDiscountAmount | Cumulative value of all discounts granted for the item during the current ReportingPeriod. | MO_DSC_EM_CM | Money | decimal(16,5) | |
| CumulativeDamagedItemDepreciationAmount | Cumulative retail value lost due to damage to stock during the current ReportingPeriod. | MO_DPC_DM_CM_ITM | Money | decimal(16,5) | |
| CumulativeOutOfDateItemDepreciationAmount | Cumulative retail value lost due to stock aging past its sell-by date during the current ReportingPeriod. | MO_DPC_OT_OF_DT | Money | decimal(16,5) | |
| EndingValueAmount | The monetary value of all Items owned by the MerchandisingCenter at the current time. | MO_VL_END | Money | decimal(16,5) | |